package cn.semcorp.zhuhaizj.mapper;

import cn.semcorp.zhuhaizj.pojo.dto.AccountingUpdateChinese;
import cn.semcorp.zhuhaizj.pojo.dto.AccountingUploadDTO;
import cn.semcorp.zhuhaizj.pojo.dto.InsertInputOutputDTO;
import cn.semcorp.zhuhaizj.pojo.dto.SelectMaterialsDTO;
import cn.semcorp.zhuhaizj.pojo.vo.AccountingVO;
import cn.semcorp.zhuhaizj.pojo.vo.MaterialsUtilizationVO;
import cn.semcorp.zhuhaizj.pojo.vo.Workshop2CodeVO;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface AccountingMapper {

    /**
     * 上传导入
     * @param list
     */
    void insertList(List<AccountingUpdateChinese> list);

    List<AccountingVO> selectMixtures(String start, String end, String workshop,String model);
    List<AccountingVO> selectMaterials(String start, String end, String workshop,String model);

    void insert(List<AccountingUploadDTO> accountingList);


    /**
     * 查询车间编码对应的车间
     */
    String selectWorkshopByCode(String code);
    List<Workshop2CodeVO> selectWorkshop();

    List<String> selectNonMassList();
    Integer selectIsMassListByMaterials(String materials);

    void addIsMassProduct(String materials);

    Integer repeatIsMass(String materials);

    List<MaterialsUtilizationVO> queryMaterialsUtilizationByRange(String workshop,String slurryName,String tickNumber,String dateQuery);

    List<MaterialsUtilizationVO> queryMaterialsUtilizationByMonth(String yearMonth,String workshop,String slurryName,String tickNumber);

    void insertInputOutput(List<InsertInputOutputDTO> list);

    List<String> selectWorkshopList();

}
